CREATE VIEW [dbo].[vSoaGroupMemberSummaryCommittee]
WITH SCHEMABINDING
AS
    SELECT  CAST([p].[PRODUCT_CODE] + ':' + [a].[ID] AS VARCHAR(50)) AS [GroupMemberId],
            CAST([p].[PRODUCT_CODE] AS VARCHAR(50)) AS [GroupId],
            [a].[ID] AS [PartyId],
            [a].[SEQN]
      FROM  [dbo].[Activity] AS [a]
            INNER JOIN [dbo].[Product] AS [p] ON [a].[PRODUCT_CODE] = [p].[PRODUCT_CODE]
     WHERE  [p].[PROD_TYPE] = 'COMMITTEE'
  


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupMemberSummaryCommittee] ON [dbo].[vSoaGroupMemberSummaryCommittee] ([SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryCommittee_GroupId] ON [dbo].[vSoaGroupMemberSummaryCommittee] ([GroupId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryCommittee] ON [dbo].[vSoaGroupMemberSummaryCommittee] ([GroupMemberId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummaryCommittee_PartyId] ON [dbo].[vSoaGroupMemberSummaryCommittee] ([PartyId]) ON [PRIMARY]
GO